package sfa.model;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.springframework.jdbc.core.RowMapper;

public class testDao extends BaseDao {
	
	public List getTest() {
		String query = "SELECT COUNT(*) as cnt FROM DBSPOTFIRE.dbo.USERS";
		
		List list = getJdbcTemplate().query(query,
				new Object[] { }, new RowMapper() {
					public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
						ArrayList alist = new ArrayList();
						alist.add(rs.getString("cnt"));
						return alist;
					}
				});
		return list;
	}
}
 